i can't get alerts related to  SQL Server 2012 in scom 2012 but i install management pack and applied it.

• Moved by Andreas BaumgartenMVP Monday, July 28, 2014 8:40 AM Wrong forum (was SCSM forum)

Wrong forum, dude.

Besides, posting a question like that with absolute minimum of detail wont get you far. What have you done to troubleshoot yourself?

1)Please check whether SQL server is discovered by SCOM. You can use Monitoring workspace --> Microsoft SQL Server --> Computers to check

2) Make sure that the following action account has required right SQL discovery Account, SQL default action Account and SQL monitoring Account

For detail, please refer to

http://blogs.technet.com/b/kevinholman/archive/2013/10/24/opsmgr-sql-mp-version-6-4-1-0-capabilities-and-configuration.aspx

Roger

Dont just presume SCOM has security access to SQL. SQL security has got "tighter" in the respect that once upon a time with the likes of SQL 2005 because you had local security access to a server and the file system you had default access to SQL.

By default the SQL 2012 installation does not grant the builtin\Admins group administrative access to SQL. If you are using the default action account and don't want to add an additional account through run-as profiles you may need to grant the local accounts access to SQL server.

-Nathan